using HKB.Common;
using System;
using System.CodeDom.Compiler;
using System.ComponentModel;
using System.ComponentModel.Design;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using System.Diagnostics;
namespace HKB.Data.Dal.H_TransferSetTableAdapters
{
	[GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0"), DataObject(true), HelpKeyword("vs.data.TableAdapter"), Designer("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"), DesignerCategory("code"), ToolboxItem(true)]
	public class HL_TransferSetTableAdapter : Component
	{
		private SqlDataAdapter _adapter;
		private SqlConnection _connection;
		private SqlCommand[] _commandCollection;
		private bool _clearBeforeFill;
		[System.Diagnostics.DebuggerNonUserCode]
		private SqlDataAdapter Adapter
		{
			get
			{
				if (this._adapter == null)
				{
					this.InitAdapter();
				}
				return this._adapter;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		internal SqlConnection Connection
		{
			get
			{
				if (this._connection == null)
				{
					this.InitConnection();
				}
				return this._connection;
			}
			set
			{
				this._connection = value;
				if (this.Adapter.InsertCommand != null)
				{
					this.Adapter.InsertCommand.Connection = value;
				}
				if (this.Adapter.DeleteCommand != null)
				{
					this.Adapter.DeleteCommand.Connection = value;
				}
				if (this.Adapter.UpdateCommand != null)
				{
					this.Adapter.UpdateCommand.Connection = value;
				}
				for (int i = 0; i < this.CommandCollection.Length; i++)
				{
					if (this.CommandCollection[i] != null)
					{
						this.CommandCollection[i].Connection = value;
					}
				}
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		protected SqlCommand[] CommandCollection
		{
			get
			{
				if (this._commandCollection == null)
				{
					this.InitCommandCollection();
				}
				return this._commandCollection;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		public bool ClearBeforeFill
		{
			get
			{
				return this._clearBeforeFill;
			}
			set
			{
				this._clearBeforeFill = value;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		public HL_TransferSetTableAdapter()
		{
			this.ClearBeforeFill = true;
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitAdapter()
		{
			this._adapter = new SqlDataAdapter();
			DataTableMapping dataTableMapping = new DataTableMapping();
			dataTableMapping.SourceTable = "Table";
			dataTableMapping.DataSetTable = "HL_TransferSet";
			dataTableMapping.ColumnMappings.Add("TransferID", "TransferID");
			dataTableMapping.ColumnMappings.Add("InterfaceID", "InterfaceID");
			dataTableMapping.ColumnMappings.Add("TransferTableName", "TransferTableName");
			dataTableMapping.ColumnMappings.Add("Other_UserID", "Other_UserID");
			dataTableMapping.ColumnMappings.Add("Other_UserName", "Other_UserName");
			dataTableMapping.ColumnMappings.Add("DBType", "DBType");
			dataTableMapping.ColumnMappings.Add("JumpUser", "JumpUser");
			dataTableMapping.ColumnMappings.Add("AccessPath", "AccessPath");
			dataTableMapping.ColumnMappings.Add("Sql_Source", "Sql_Source");
			dataTableMapping.ColumnMappings.Add("Sql_Name", "Sql_Name");
			dataTableMapping.ColumnMappings.Add("Sql_user", "Sql_user");
			dataTableMapping.ColumnMappings.Add("Sql_Pass", "Sql_Pass");
			dataTableMapping.ColumnMappings.Add("TransferType", "TransferType");
			dataTableMapping.ColumnMappings.Add("Md5Size", "Md5Size");
			dataTableMapping.ColumnMappings.Add("AutoID", "AutoID");
			dataTableMapping.ColumnMappings.Add("InterfaceName", "InterfaceName");
			this._adapter.TableMappings.Add(dataTableMapping);
			this._adapter.DeleteCommand = new SqlCommand();
			this._adapter.DeleteCommand.Connection = this.Connection;
			this._adapter.DeleteCommand.CommandText = "DELETE FROM [HL_TransferSet] WHERE (([TransferID] = @Original_TransferID))";
			this._adapter.DeleteCommand.CommandType = CommandType.Text;
			this._adapter.DeleteCommand.Parameters.Add(new SqlParameter("@Original_TransferID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TransferID", DataRowVersion.Original, false, null, "", "", ""));
			this._adapter.InsertCommand = new SqlCommand();
			this._adapter.InsertCommand.Connection = this.Connection;
			this._adapter.InsertCommand.CommandText = "INSERT INTO [HL_TransferSet] ([InterfaceID], [TransferTableName], [Other_UserID], [Other_UserName], [DBType], [JumpUser], [AccessPath], [Sql_Source], [Sql_Name], [Sql_user], [Sql_Pass], [TransferType], [Md5Size], [AutoID]) VALUES (@InterfaceID, @TransferTableName, @Other_UserID, @Other_UserName, @DBType, @JumpUser, @AccessPath, @Sql_Source, @Sql_Name, @Sql_user, @Sql_Pass, @TransferType, @Md5Size, @AutoID)";
			this._adapter.InsertCommand.CommandType = CommandType.Text;
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@InterfaceID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "InterfaceID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TransferTableName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "TransferTableName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Other_UserID", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Other_UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Other_UserName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Other_UserName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@DBType", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "DBType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@JumpUser", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "JumpUser", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@AccessPath", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "AccessPath", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Sql_Source", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Sql_Source", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Sql_Name", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Sql_Name", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Sql_user", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Sql_user", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Sql_Pass", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Sql_Pass", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TransferType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TransferType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Md5Size", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Md5Size", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@AutoID", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "AutoID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand = new SqlCommand();
			this._adapter.UpdateCommand.Connection = this.Connection;
			this._adapter.UpdateCommand.CommandText = "UPDATE [HL_TransferSet] SET [InterfaceID] = @InterfaceID, [TransferTableName] = @TransferTableName, [Other_UserID] = @Other_UserID, [Other_UserName] = @Other_UserName, [DBType] = @DBType, [JumpUser] = @JumpUser, [AccessPath] = @AccessPath, [Sql_Source] = @Sql_Source, [Sql_Name] = @Sql_Name, [Sql_user] = @Sql_user, [Sql_Pass] = @Sql_Pass, [TransferType] = @TransferType, [Md5Size] = @Md5Size, [AutoID] = @AutoID WHERE (([TransferID] = @Original_TransferID))";
			this._adapter.UpdateCommand.CommandType = CommandType.Text;
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@InterfaceID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "InterfaceID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TransferTableName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "TransferTableName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Other_UserID", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Other_UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Other_UserName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Other_UserName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@DBType", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "DBType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@JumpUser", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "JumpUser", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@AccessPath", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "AccessPath", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Sql_Source", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Sql_Source", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Sql_Name", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Sql_Name", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Sql_user", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Sql_user", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Sql_Pass", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Sql_Pass", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TransferType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TransferType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Md5Size", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Md5Size", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@AutoID", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "AutoID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Original_TransferID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TransferID", DataRowVersion.Original, false, null, "", "", ""));
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitConnection()
		{
			this._connection = new SqlConnection();
			this._connection.ConnectionString = Conn.CurrenConnectionStrings;
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitCommandCollection()
		{
			this._commandCollection = new SqlCommand[5];
			this._commandCollection[0] = new SqlCommand();
			this._commandCollection[0].Connection = this.Connection;
			this._commandCollection[0].CommandText = "SELECT TransferID, InterfaceID, TransferTableName, Other_UserID, Other_UserName, \r\n      DBType, JumpUser, AccessPath, Sql_Source, Sql_Name, Sql_user, Sql_Pass, \r\n      TransferType, Md5Size, AutoID,(Select InterfaceName From HL_Interface WHERE HL_Interface.InterfaceID=HL_TransferSet.InterfaceID)As InterfaceName\r\nFROM HL_TransferSet";
			this._commandCollection[0].CommandType = CommandType.Text;
			this._commandCollection[1] = new SqlCommand();
			this._commandCollection[1].Connection = this.Connection;
			this._commandCollection[1].CommandText = "INSERT INTO [HL_TransferSet] ([InterfaceID], [TransferTableName], [Other_UserID], [Other_UserName], [DBType], [JumpUser], [AccessPath], [Sql_Source], [Sql_Name], [Sql_user], [Sql_Pass], [TransferType], [Md5Size], [AutoID]) VALUES (@InterfaceID, @TransferTableName, @Other_UserID, @Other_UserName, @DBType, @JumpUser, @AccessPath, @Sql_Source, @Sql_Name, @Sql_user, @Sql_Pass, @TransferType, @Md5Size, @AutoID)";
			this._commandCollection[1].CommandType = CommandType.Text;
			this._commandCollection[1].Parameters.Add(new SqlParameter("@InterfaceID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "InterfaceID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@TransferTableName", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, "TransferTableName", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Other_UserID", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, "Other_UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Other_UserName", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, "Other_UserName", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@DBType", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, "DBType", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@JumpUser", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "JumpUser", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@AccessPath", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, "AccessPath", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Sql_Source", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, "Sql_Source", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Sql_Name", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, "Sql_Name", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Sql_user", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, "Sql_user", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Sql_Pass", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, "Sql_Pass", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@TransferType", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "TransferType", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Md5Size", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "Md5Size", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@AutoID", SqlDbType.Bit, 1, ParameterDirection.Input, 0, 0, "AutoID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2] = new SqlCommand();
			this._commandCollection[2].Connection = this.Connection;
			this._commandCollection[2].CommandText = "DELETE FROM [HL_TransferSet] WHERE (([TransferID] = @TransferID));DELETE From [HL_TransferField] WHERE (([TransferID] = @TransferID))";
			this._commandCollection[2].CommandType = CommandType.Text;
			this._commandCollection[2].Parameters.Add(new SqlParameter("@TransferID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "TransferID", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[3] = new SqlCommand();
			this._commandCollection[3].Connection = this.Connection;
			this._commandCollection[3].CommandText = "SELECT TOP 1 AccessPath, AutoID, DBType, InterfaceID, JumpUser, Md5Size, Other_UserID, Other_UserName, Sql_Name, Sql_Pass, Sql_Source, Sql_user, TransferID, TransferTableName, TransferType FROM HL_TransferSet ORDER BY TransferID DESC";
			this._commandCollection[3].CommandType = CommandType.Text;
			this._commandCollection[4] = new SqlCommand();
			this._commandCollection[4].Connection = this.Connection;
			this._commandCollection[4].CommandText = "SELECT TransferID, InterfaceID, TransferTableName, Other_UserID, Other_UserName, \r\n      DBType, JumpUser, AccessPath, Sql_Source, Sql_Name, Sql_user, Sql_Pass, \r\n      TransferType, Md5Size, AutoID,(Select InterfaceName From HL_Interface WHERE HL_Interface.InterfaceID=HL_TransferSet.InterfaceID)As InterfaceName\r\nFROM HL_TransferSet\r\nWHERE TransferID=@TransferID\r\n";
			this._commandCollection[4].CommandType = CommandType.Text;
			this._commandCollection[4].Parameters.Add(new SqlParameter("@TransferID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "TransferID", DataRowVersion.Current, false, null, "", "", ""));
		}
		[DataObjectMethod(DataObjectMethodType.Select, true), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_TransferSet.HL_TransferSetDataTable GetAllTransferSet()
		{
			this.Adapter.SelectCommand = this.CommandCollection[0];
			H_TransferSet.HL_TransferSetDataTable hL_TransferSetDataTable = new H_TransferSet.HL_TransferSetDataTable();
			this.Adapter.Fill(hL_TransferSetDataTable);
			return hL_TransferSetDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_TransferSet.HL_TransferSetDataTable GetLastTransferID()
		{
			this.Adapter.SelectCommand = this.CommandCollection[3];
			H_TransferSet.HL_TransferSetDataTable hL_TransferSetDataTable = new H_TransferSet.HL_TransferSetDataTable();
			this.Adapter.Fill(hL_TransferSetDataTable);
			return hL_TransferSetDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_TransferSet.HL_TransferSetDataTable GetTransferSetByTransferID(int TransferID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[4];
			this.Adapter.SelectCommand.Parameters[0].Value = TransferID;
			H_TransferSet.HL_TransferSetDataTable hL_TransferSetDataTable = new H_TransferSet.HL_TransferSetDataTable();
			this.Adapter.Fill(hL_TransferSetDataTable);
			return hL_TransferSetDataTable;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(H_TransferSet.HL_TransferSetDataTable dataTable)
		{
			return this.Adapter.Update(dataTable);
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(H_TransferSet dataSet)
		{
			return this.Adapter.Update(dataSet, "HL_TransferSet");
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(DataRow dataRow)
		{
			return this.Adapter.Update(new DataRow[]
			{
				dataRow
			});
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(DataRow[] dataRows)
		{
			return this.Adapter.Update(dataRows);
		}
		[DataObjectMethod(DataObjectMethodType.Insert, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int AddNewTransferSet(int? InterfaceID, string TransferTableName, string Other_UserID, string Other_UserName, string DBType, int? JumpUser, string AccessPath, string Sql_Source, string Sql_Name, string Sql_user, string Sql_Pass, int? TransferType, int? Md5Size, bool? AutoID)
		{
			SqlCommand sqlCommand = this.CommandCollection[1];
			if (InterfaceID.HasValue)
			{
				sqlCommand.Parameters[0].Value = InterfaceID.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (TransferTableName == null)
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = TransferTableName;
			}
			if (Other_UserID == null)
			{
				sqlCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[2].Value = Other_UserID;
			}
			if (Other_UserName == null)
			{
				sqlCommand.Parameters[3].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[3].Value = Other_UserName;
			}
			if (DBType == null)
			{
				sqlCommand.Parameters[4].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[4].Value = DBType;
			}
			if (JumpUser.HasValue)
			{
				sqlCommand.Parameters[5].Value = JumpUser.Value;
			}
			else
			{
				sqlCommand.Parameters[5].Value = System.DBNull.Value;
			}
			if (AccessPath == null)
			{
				sqlCommand.Parameters[6].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[6].Value = AccessPath;
			}
			if (Sql_Source == null)
			{
				sqlCommand.Parameters[7].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[7].Value = Sql_Source;
			}
			if (Sql_Name == null)
			{
				sqlCommand.Parameters[8].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[8].Value = Sql_Name;
			}
			if (Sql_user == null)
			{
				sqlCommand.Parameters[9].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[9].Value = Sql_user;
			}
			if (Sql_Pass == null)
			{
				sqlCommand.Parameters[10].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[10].Value = Sql_Pass;
			}
			if (TransferType.HasValue)
			{
				sqlCommand.Parameters[11].Value = TransferType.Value;
			}
			else
			{
				sqlCommand.Parameters[11].Value = System.DBNull.Value;
			}
			if (Md5Size.HasValue)
			{
				sqlCommand.Parameters[12].Value = Md5Size.Value;
			}
			else
			{
				sqlCommand.Parameters[12].Value = System.DBNull.Value;
			}
			if (AutoID.HasValue)
			{
				sqlCommand.Parameters[13].Value = AutoID.Value;
			}
			else
			{
				sqlCommand.Parameters[13].Value = System.DBNull.Value;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Delete, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int DeleteTransferSet(int TransferID)
		{
			SqlCommand sqlCommand = this.CommandCollection[2];
			sqlCommand.Parameters[0].Value = TransferID;
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
	}
}
